package com.bm.server.dao;

import com.baomidou.mybatisplus.core.mapper.BaseMapper;
import com.bm.server.dto.AllyListDto;
import com.bm.server.entity.Ally;
import org.apache.ibatis.annotations.Select;

import java.util.List;

/**
 * Hey man，take your time！
 *
 * @Author: 李松洋
 * @Description:代码永不报错，工资永在上涨！！！
 * @Date: Create in 15:49 2022/7/22
 */
public interface AllyInfoDao extends BaseMapper<Ally> {
    //展示联盟
    @Select("SELECT a.allyname,a.allypath,m.allyinfo,u.nickname FROM  t_ally AS a\n" +
            "INNER JOIN t_allymid AS m\n" +
            "ON a.allyid=m.allyid\n" +
            "INNER JOIN t_userinfo AS u\n" +
            "ON a.uid= u.uid")
    List<AllyListDto> queryInfo();
 
}
